#посмотреть
▫️Условия задачи
▫️Создание таблицы для экспериментов в PostgreSQL
▫️Объединение таблицы с самой собой (SELF JOIN)
▫️Записываем условие фильтрации
▫️Проверка решения на Leetcode
BY SQL для тестировщика
China’s stock markets are some of the largest in the world, with total market capitalization reaching RMB 79 trillion (US$12.2 trillion) in 2020. China’s stock markets are seen as a crucial tool for driving economic growth, in particular for financing the country’s rapidly growing high-tech sectors.Although traditionally closed off to overseas investors, China’s financial markets have gradually been loosening restrictions over the past couple of decades. At the same time, reforms have sought to make it easier for Chinese companies to list on onshore stock exchanges, and new programs have been launched in attempts to lure some of China’s most coveted overseas-listed companies back to the country.
SQL для тестировщика from id